SET time_zone = '+00:00'

DELETE
FROM `session`
WHERE `expire` < '2024-05-07 13:42:18'

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')

SELECT `data`
FROM `session`
WHERE `session_id` = '121aba3761e904aec90fe387c4' AND `expire` > '2024-05-07 13:42:18'

SELECT *
FROM store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://iparts-4u.co.uk/'

SELECT *
FROM `setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

SET time_zone = '+01:00'

SELECT *
FROM currency

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '222' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4229')
ORDER BY tr1.priority ASC

SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '222' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4229')
ORDER BY tr1.priority ASC

SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'

SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'

DELETE
FROM cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)

SELECT *
FROM `event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC

SELECT count(*) AS total
FROM `journal3_skin`

SELECT `key`, `value`, `serialized`
FROM setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'

SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '121aba3761e904aec90fe387c4'

SELECT *
FROM layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1

SELECT layout_id, layout_data
FROM `journal3_layout`
WHERE `layout_id` = '1' OR `layout_id` = -1
ORDER BY `layout_id` DESC

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/css'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '379'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/info_blocks'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '377'

SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '28' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'information_id=28' AND store_id = '0' AND language_id = '1'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '430'

SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '36' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'information_id=36' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '1073' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=1073' AND store_id = '0' AND language_id = '1'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '431'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '411'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '14' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=14' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '32' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=32' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '146' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=146' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '656' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=656' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '57' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=57' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '836' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=836' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '200' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=200' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '737' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=737' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '743' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=743' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '701' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=701' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '666' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=666' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '987' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=987' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '989' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=989' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '693' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=693' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '837' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=837' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '999' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=999' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '720' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'category_id=720' AND store_id = '0' AND language_id = '1'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '255'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '282'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/title'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '284'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/title'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '429'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '408'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '285'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/title'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '446'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '407'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '204'

SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '35' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'information_id=35' AND store_id = '0' AND language_id = '1'

SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '35' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'information_id=35' AND store_id = '0' AND language_id = '1'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '409'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '427'

SELECT DISTINCT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '6' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'information_id=6' AND store_id = '0' AND language_id = '1'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'product/product' OR route = 'en-gb')

SELECT *
FROM `journal3_module`
WHERE `module_id` = '234'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id IN (9331,8866,12441,9624,9608,1556,9454,9440) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT p.product_id, ( SELECT AVG(rating) total
FROM `review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1 ) discount, ( SELECT price
FROM `product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1 ) special, p.viewed
FROM `product` p
LEFT JOIN `product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '1' GROUP BY p.product_id
ORDER BY p.date_added DESC, LCASE(pd.name) DESC LIMIT 0, 8

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id IN (15088,15087,15086,15085,15084,15083,15082,15081) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=9331' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=8866' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=12441' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=9624' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=9608' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=1556' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=9454' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=9440' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=15088' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=15087' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=15086' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=15085' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=15084' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=15083' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=15082' AND store_id = '0' AND language_id = '1'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM seo_url
WHERE `query` = 'product_id=15081' AND store_id = '0' AND language_id = '1'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/products'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '433'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '434'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '435'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '436'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '437'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/banners'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '432'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/title'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/blocks'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/top'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'

SELECT *
FROM `journal3_module`
WHERE `module_id` = '0'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/newsletter'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/icons_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/title'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'en-gb')

SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/isenselabs_gdpr' OR route = 'en-gb')

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/oc3/notifyform'

DELETE
FROM `customer_online`
WHERE date_added < '2024-05-07 13:42:18'

REPLACE INTO `customer_online` SET `ip` = '18.221.222.47', `customer_id` = '0', `url` = 'https://www.iparts-4u.co.uk/', `referer` = 'http://iparts-4u.co.uk/', `date_added` = '2024-05-07 14:42:18'

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'

SELECT *
FROM extension
ORDER BY code

SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'd_seo_extension'